package com.hamilton.erik.pt.core.dao;

import java.sql.SQLException;
import java.util.List;

import com.hamilton.erik.pt.core.model.Note;

public interface NoteDAO {
	
	public final static String ANIMAL_NOTES_DB_TABLE = "APPLICATION.ANIMAL_NOTES";
	public final static String ENCLOSURE_NOTES_DB_TABLE = "APPLICATION.ENCLOSURE_NOTES";
	public final static String ENCLOSURE_MAINTENANCE_NOTES_DB_TABLE = "APPLICATION.ENCLOSURE_MAINTENANCE_NOTES";
	public final static String FEEDING_NOTES_DB_TABLE = "APPLICATION.FEEDING_NOTES";
	public final static String MEDICAL_RECORD_NOTES_DB_TABLE = "APPLICATION.MEDICAL_RECORD_NOTES";

	public int insertNote(Note note, String table) throws SQLException;
	public boolean deleteNote(Long noteId, String table) throws SQLException;
	public Note findNote(Note note, String table) throws SQLException;
	public int updateNote(Note note, String table) throws SQLException;
	
	public List<Note> getAllNotes(Long referenceId, String table) throws SQLException;
	public boolean deleteAllNotes(Long referenceId, String table) throws SQLException;
	

}
